Total Complexity | 2 |
Total Lines | 12 |
Duplicated Lines | 0 % |
Changes | 0 |
1 | import {MigrationInterface, QueryRunner} from "typeorm"; |
||
2 | |||
3 | export class Voucher1617438352492 implements MigrationInterface { |
||
4 | name = 'Voucher1617438352492' |
||
5 | |||
6 | public async up(queryRunner: QueryRunner): Promise<void> { |
||
7 | await queryRunner.query(`CREATE TABLE "voucher" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "code" character varying NOT NULL, "email" character varying NOT NULL, "createdAt" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, "schoolId" uuid NOT NULL, CONSTRAINT "PK_677ae75f380e81c2f103a57ffaf" PRIMARY KEY ("id"))`); |
||
8 | await queryRunner.query(`ALTER TABLE "voucher" ADD CONSTRAINT "FK_c837a392c774db4d54bc8d8484c" FOREIGN KEY ("schoolId") REFERENCES "school"("id") ON DELETE CASCADE ON UPDATE NO ACTION`); |
||
9 | } |
||
10 | |||
11 | public async down(queryRunner: QueryRunner): Promise<void> { |
||
12 | await queryRunner.query(`ALTER TABLE "voucher" DROP CONSTRAINT "FK_c837a392c774db4d54bc8d8484c"`); |
||
13 | await queryRunner.query(`DROP TABLE "voucher"`); |
||
14 | } |
||
17 |